Low Amount of WHOIS Queries after Applying Site Server
Service Pack 3 |
The information in this article applies to:
- Microsoft Site Server version 3.0
SYMPTOMS
After you install Site Server 3.0 Service Pack 3 on a computer
that uses the Analysis tools against a SQL Server 7.0 database, a
large reduction in the amount of organization look ups may occur
when WHOIS queries are performed against any new Analysis databases.
A large number of Unknown Organizations may also be reported
when you do Analysis reports against referring domains.
CAUSE
This problem occurs due to changes in a stored procedure used by
the Usage Import application.
NOTE: This problem only occurs
with new Analysis databases created in SQL Server 7.0, after Site
Server 3.0 Service Pack 3 is applied. This problem does not affect
SQL Server 6.5 databases or pre-existing SQL Server 7.0 databases.
RESOLUTION
A supported fix that corrects this problem is now available from
Microsoft, but it has not been fully regression tested and should be
applied only to systems experiencing this specific problem. If you
are not severely affected by this specific problem, Microsoft
recommends that you wait for the next Site Server service pack that
contains this fix.
To resolve this problem immediately,
contact Microsoft Product Support Services to obtain the fix. For a
complete list of Microsoft Product Support Services phone numbers
and information on support costs, please go to the following address
on the World Wide Web:
http://www.microsoft.com/support/supportnet/overview/overview.asp
The
English version of this fix should have the following file
attributes or later:
Size File name Platform
---------------------------------
2,262,016 UAHOT_I.EXE Intel
2,473,984 UAHOT_A.EXE Alpha
STATUS
Microsoft has confirmed this to be a problem in Site Server
3.0.
MORE INFORMATION
After you apply this fix, you must either create a new Analysis
database with the Database Setup Wizard and re-import your logs or
use the following steps to preserve the Log Data Source, Server and
Site properties:
- Start Usage Import.
- Delete your current imported log files using Import History
Manager.
- Close Usage Import.
- Run Database Setup from the Start Menu.
- Click Next.
- Select Update an existing database, and then click
Next.
- Enter the connection information for the database you want to
update, and then click Connect.
- Disable all check boxes except the Create stored
procedures check box. It is important that this is the only
check box that is selected. Selecting other check boxes will
result in data loss. Click Update DB.
- Click OK to confirm that the database was
updated.
- Click Finish.
- When the Database Setup completes, re-import your log
files.
Additional query words:
Keywords :
Version : winnt:3.0
Platform : winnt
Issue
type : kbbug
.gif){kind=spacer}